/******************************************************************
 * Copyright (c) 2007 - 2007, Simon Guerard, All rights reserved.
 * 
 * Projet de jeu de course au large.
 * 
 * This File is part of Sail-Race
 * 
 * Sail-Race is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
 * 
 * Sail-Race is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
 * of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License along with Sail-Race; if not, write to the Free
 * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
 */

package net.simcafamily.sailrace.db;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import javax.annotation.Resource;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

/**
 * @author Simon Guerard
 * 
 */
@Repository("initDB")
public class InitDB {

    @Resource
    private JdbcTemplate jdbcTemplate;

    @Autowired
    public void init() throws IOException {
	InputStream io = InitDB.class.getResourceAsStream("createDb.sql");
	BufferedReader reader = new BufferedReader(new InputStreamReader(io));
	String line = reader.readLine();
	List<String> sql = new ArrayList<String>();
	while (line != null) {
	    sql.add(line);
	    line = reader.readLine();
	}
	jdbcTemplate.batchUpdate(sql.toArray(new String[sql.size()]));
    }
}
